StudentAward

EntityType | Dependent
Logical Entity Name | StudentAward
Default Table Name | FaStudentAid
Logical Only | NO
Owner | dbo
Definition |
Note |

StudentAward Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
StudentAwardId |  | INTEGER | NO |
StudentId |  | INTEGER | NO |
StudentEnrollmentPeriodId |  | INTEGER | YES |
StudentRelationshipAddressId |  | INTEGER | YES |
Source |  | CHAR(1) | YES |
FundSourceId |  | INTEGER | YES |
AwardYear |  | CHAR(7) | YES |
AgencyBranchId |  | INTEGER | YES |
FaLenderId |  | INTEGER | YES |
ServicerLendingInstitutionId |  | INTEGER | YES |
GuarantorLendingInstitutionId |  | INTEGER | YES |
AmountPackaged |  | MONEY(19, 4) | NO |
LenderFee |  | MONEY(19, 4) | NO |
AmountDisbursed |  | MONEY(19, 4) | NO |
AmountCanceled |  | MONEY(19, 4) | NO |
AmountRefunded |  | MONEY(19, 4) | NO |
LoanPeriodBeginDate |  | DATETIME | YES |
LoanPeriodEndDate |  | DATETIME | YES |
ApplicationSentDate |  | DATETIME | YES |
ApplicationReceivedDate |  | DATETIME | YES |
StudentAcademicYearId |  | INTEGER | YES |
FirstPaymentDate |  | DATETIME | YES |
LastInterestDate |  | DATETIME | YES |
PaymentDay |  | TINYINT | YES |
PaymentFrequency |  | SMALLINT | YES |
InterestRate |  | NUMERIC(5, 2) | YES |
NumberPayments |  | SMALLINT | YES |
TotalAmountPaid |  | MONEY(19, 4) | YES |
PrincipalBalance |  | MONEY(19, 4) | YES |
InterestBalance |  | MONEY(19, 4) | YES |
NextPaymentDate |  | DATETIME | YES |
PaymentAmount |  | MONEY(19, 4) | YES |
Status |  | CHAR(1) | YES |
Note |  | TEXT | YES |
LastModifiedUserId |  | INTEGER | NO |
CreatedDateTime |  | DATETIME | NO |
LastModifiedDateTime |  | DATETIME | NO |
RowVersion |  | TIMESTAMP/DATE | NO |
StudentAwardPellId |  | INTEGER | YES |
IsBankFeeIncludedInCoa |  | BIT | NO |
InterestRebateAmount |  | NUMERIC(18, 0) | YES |
ServicerRecordIdentifier |  | CHAR(20) | YES |
CreatedByUserId |  | INTEGER | NO |
BatchPackagingProcessId |  | INTEGER | YES |
IsEstimatedAward |  | BIT | NO |
SecondaryInterestRate |  | NUMERIC(6, 3) | YES |
SecondaryInterestRateEffectiveDate |  | DATETIME | YES |
InterestOnlyUntilDate |  | DATETIME | YES |
AccruedInterestAmount |  | MONEY(19, 4) | NO |
IsAutoDraft |  | BIT | NO |
EffectiveDate |  | DATETIME | YES |
StudentBankAccountId |  | INTEGER | YES |
StudentCreditCardId |  | INTEGER | YES |
IsAutoCredit |  | BIT | NO |
CreditCardEffectiveDate |  | DATETIME | YES |
IsT4BalanceEvaluated |  | BIT | NO |
LastStatementPrintDate |  | DATETIME | YES |
LastPromNotePrintDate |  | DATETIME | YES |
CodGrantOriginationId |  | INTEGER | YES |
IsLocked |  | BIT | NO |
LockedByUserId |  | INTEGER | YES |
DownPaymentAmount |  | MONEY(19, 4) | YES |
PromNoteDocumentId |  | INTEGER | YES |
CalculationDate |  | DATETIME | YES |
LoanIdentificationNumber |  | INTEGER | YES |
IsReAllocated |  | BIT | NO |
Rep9010DiscountRate |  | NUMERIC(5, 2) | YES |
Rep9010CollectionRate |  | NUMERIC(5, 2) | YES |
Rep9010NumberOfYears |  | SMALLMONEY | YES |
StudentLoanPeriodId |  | INTEGER | YES |
LoanAcademicYearStartDate |  | DATETIME | YES |
LoanAcademicYearEndDate |  | DATETIME | YES |
IsAXLinkedFWS |  | BIT | NO |
StudentId |  | INTEGER | YES |
StudentCreditCardId |  | INTEGER | YES |

StudentAward Keys

Key Name | Key Type | Keys
FaStudentAid_DateLoanStart_DateLoanEnd_N_N_IDX | Inversion Entry | LoanPeriodBeginDate, LoanPeriodEndDate
FaStudentAid_SyStudentID_AwardYear_FaFundSourceID_FaStudentAidID_U_N_IDX | Alternate Key | StudentId, AwardYear, FundSourceId, StudentAwardId
FaStudentAid_AwardYear_FaStudentAidID_U_N_IDX | Alternate Key | AwardYear, StudentAwardId
FaStudentAid_FaStudentAYID_N_N_IDX | Inversion Entry | StudentAcademicYearId
FaStudentAid_FaStudentAidID_U_C_IDX | PrimaryKey | StudentAwardId
Nk_FaStudentAidPromNoteCMDocumentID_CmDocumentCmDocumentId | Inversion Entry | PromNoteDocumentId
FaStudentAid_SaStudentBankAccountID_N_N_IDX | Inversion Entry | StudentBankAccountId
FaStudentAid_SaCcId_N_N_IDX | Inversion Entry | StudentCreditCardId
FaStudentAid_FaBatchPackageID_N_N_IDX | Inversion Entry | BatchPackagingProcessId
FaStudentAid_SyStudentID_IsAutoCredit_U_N_IDX | Inversion Entry | StudentId, IsAutoCredit
FaStudentAid_SyStudentID_IsAutoDraft_U_N_IDX | Inversion Entry | StudentId, IsAutoDraft
FaStudentAid_Source_N_N_IDX | Inversion Entry | Source
FaStudentAid_ServicerRecordID_N_N_IDX | Inversion Entry | ServicerRecordIdentifier
FaStudentAid_FaStudentPellID_N_N_IDX | Inversion Entry | StudentAwardPellId
FaStudentAid_FaFundSourceID_N_N_IDX | Inversion Entry | FundSourceId
NK_FaStudentAid_AwardYear_INCL | Inversion Entry | AwardYear
FaStudentAid_FaCODGrantID_FaStudentAidID_U_N_IDX | Alternate Key | CodGrantOriginationId, StudentAwardId
FaStudentAid_FaFundSourceID_FaBankID_Source_N_N_IDX | Inversion Entry | StudentAwardId, FaLenderId, Source
Nk_FaStudentAid_Id_AdEnrollId_StudentAYId_FundSourceId_AwardYear | Inversion Entry | StudentAwardId, StudentAcademicYearId, FundSourceId, AwardYear
Uk_FaStudentAid_FaFundSourceID_AwardYear_Status_AdEnrollID_FaStudentPellID_SyStudentID_FaStudentAidID | Alternate Key | FundSourceId, AwardYear, Status, StudentAwardPellId, StudentId, StudentAwardId
FaStudentAid_AdEnrollID_Source_FaFundSourceID_AwardYear_Status_N_N_IDX | Inversion Entry | Source, FundSourceId, AwardYear, Status
FaStudentAid_Status_FaFundSourceID_AwardYear_FaBankID_AdEnrollID_FaStudentAidID_SyStudentID_N_N_IDX | Inversion Entry | Status, FundSourceId, AwardYear, FaLenderId, StudentAwardId, StudentId
Nk_FaStudentAid_Id_AdEnrollId_FundSourceId_AwardYear_BankId_LoanDates | Inversion Entry | StudentAwardId, FundSourceId, AwardYear, FaLenderId, GuarantorLendingInstitutionId, LoanPeriodBeginDate, LoanPeriodEndDate

StudentAward Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype
LendingInstitution | Non-Identifying | Zero or One to Zero or More |  |  |  | FaLenderId | NO
BatchPackagingProcess | Non-Identifying | Zero or One to Zero or More |  |  |  | BatchPackagingProcessId | NO
CodGrantOrigination | Non-Identifying | Zero or One to Zero or More |  |  |  | CodGrantOriginationId | NO
FundSource | Non-Identifying | Zero or One to Zero or More |  |  |  | FundSourceId | NO
StudentAwardPell | Identifying | One To Zero or More |  |  |  | StudentAwardId | NO
StudentAcademicYear | Non-Identifying | Zero or One to Zero or More |  |  |  | StudentAcademicYearId | NO
StudentCreditCard | Non-Identifying | Zero or One to Zero or More |  |  |  | StudentCreditCardId | NO
StudentBankAccount | Non-Identifying | Zero or One to Zero or More |  |  |  | StudentBankAccountId | NO
Student | Non-Identifying | One To Zero or More |  |  |  | StudentId | NO
Student | Non-Identifying | Zero or One to Zero or More |  |  |  | StudentId | NO
StudentCreditCard | Non-Identifying | Zero or One to Zero or More |  |  |  | StudentCreditCardId | NO
StudentEnrollmentPeriod | Non-Identifying | Zero or One to Zero or More |  |  |  | StudentEnrollmentPeriodId | NO
StudentRelationshipAddress | Non-Identifying | Zero or One to Zero or More |  |  |  | StudentRelationshipAddressId | NO

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype
FaCampusVantageWorkStudyPayroll | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaCashPlanWorkflowAudit | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaCodActualDisb_REG | Non-Identifying | One To Zero or More |  |  |  |  | NO
CodGrantDisbursement | Non-Identifying | One To Zero or More |  |  |  |  | NO
PaidDisbursement | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentAwardLoan | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaLoanCommonLineChangeSendLog | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentAwardPromNotePrintAssignment | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaPromNotePrintAssignmentHistory_FAA | Non-Identifying | One To Zero or More |  |  |  |  | NO
Refund | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentAwardCalculation | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaStudentAidCashPlanAssignment | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaStudentAidCashPlanHistory | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentAwardCalculation | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentAcademicYearPaymentPeriod | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentAcademicYearLoanPaymentPeriod | Non-Identifying | One To Zero or More |  |  |  |  | NO
CollectionAccount | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentStatement | Non-Identifying | One To Zero or More |  |  |  |  | NO
SyAudit_FaStudentAid | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaaProcessSourceRecord | Non-Identifying | One To Zero or More |  |  |  |  | NO
CollectionAccount | Non-Identifying | One To Zero or More |  |  |  |  | NO
PaidDisbursement | Non-Identifying | One To Zero or More |  |  |  |  | NO
Refund | Non-Identifying | Zero or One to Zero or More |  |  |  |  | NO
ScheduledDisbursement | Non-Identifying | One To Zero or More |  |  |  |  | NO
StipendSchedule | Non-Identifying | Zero or One to Zero or More |  |  |  |  | NO
StudentAccountTransaction | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentRefundCalculationFundSourceSummary | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentRt4CalculationStudentAward | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentStatement | Non-Identifying | One To Zero or More |  |  |  |  | NO

StudentAward Check Constraints

Check Constraint Name | CheckConstraint
Chk_FaStudentAid_IntOnlyUntilDate | ([IntOnlyUntilDate] is null and [FirstPayDate] is null or [IntOnlyUntilDate] is null and [FirstPayDate] is not null or [IntOnlyUntilDate] is not null and [FirstPayDate] is not null and [IntOnlyUntilDate] > [FirstPayDate])
Chk_FaStudentAid_SecondaryInterestRateEffDate | ([SecondaryInterestRateEffDate] is null and [FirstPayDate] is null or [SecondaryInterestRateEffDate] is null and [FirstPayDate] is not null or [SecondaryInterestRateEffDate] is not null and [FirstPayDate] is not null and [SecondaryInterestRateEffDate] > [FirstPayDate])

StudentAward Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.StudentAward | NO |  |  |
Physical (Microsoft SQL Server) dbo.FaStudentAid | NO |  |  |

StudentAward Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Logical | LedgerCard_Billing
Logical | RefundCalculation
Logical | Refunds_Stipends
Logical | StudentPayments_Collections
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Financial Aid

StudentAward Data Movement Rules

Name | Type | Rule Text/Value